Why is my Recursive CTE not returning all values after the UNION ALL operation